Data import sequence

There are a few Reference tables with look ups to other reference tables. In those cases, import the referenced tables first. With this exception, you can load reference table data loads in any order. It may need to refresh the various reference tables more frequently than others. (For example, you need to update Provider and CostItem more frequently than MSDRG and HCPCS).

Make sure to first import Data table loads with the Patient and Encounter imports. This is due to the dependency of the other tables to encounter data table based on the Encounter Seq. Execute Encounter Staging before Encounter. After you load the Encounter table for the specific period, you can perform the other imports in any sequence, with one exception. You must execute Cost Detail Staging before CostDetail.

The following table lists the recommended order for loading the files, however, you can run the remaining imports in any order.

File #	Name
1	Encounter Patient
2	Encounter Staging
3	Encounter
4	Encounter Custom
5	CostDetail Staging
6	CostDetail
7	Enc_CPT
8	Enc_Diag
9	Enc_Payment
10	Enc_Payor
11	Enc_Proc
12	Enc_Provider
13	Surgical